Lesson 07 - Basic Formulas in Excel

🧮 Formula Kya Hai?

Hindi: Excel mein calculation karne ke liye Formula ka use kiya jata hai.

English: A formula is an expression used to perform calculations in Excel.

Excel mein formula hamesha = sign se start hota hai.

=10+20

➕ Addition

Do ya usse zyada numbers ko add karne ke liye + operator ka use hota hai.

=10+20

Result = 30

Excel automatically calculation karke result show karega.

🔲 Cell Reference

Formula mein directly numbers likhne ke bajay hum cells ka reference bhi use kar sakte hain.

A1 = 100
A2 = 200

Formula:
=A1+A2

Result = 300

➖ Subtraction

Numbers ko subtract karne ke liye - operator ka use hota hai.

=50-20

Result = 30

Cell references ke saath bhi subtraction kiya ja sakta hai.

A1 = 500
A2 = 150

=A1-A2

Result = 350

✖️ Multiplication

Excel mein multiplication ke liye * operator use hota hai.

=10*5

Result = 50

➗ Division

Division ke liye Excel mein / operator use hota hai.

=100/5

Result = 20

🔢 Basic Operators

Excel mein basic mathematical operators:

+ → Addition
- → Subtraction
* → Multiplication
/ → Division

📊 Total Calculate Karna

Maan lijiye sales data mein kuch amounts hain.

A1 = 1000
A2 = 2000
A3 = 1500

Formula:
=A1+A2+A3

Result = 4500

💼 Business Example

Business mein Price aur Quantity ko multiply karke Total Amount calculate kiya ja sakta hai.

Price = ₹500
Quantity = 4

Formula:
=500*4

Total = ₹2000

📌 Formula Bar

Excel ke top par Formula Bar hoti hai. Ismein selected cell ka data ya formula dekha aur edit kiya ja sakta hai.

Cell: C2

Formula Bar:
=A2+B2

⚠️ Important Note

Excel mein formula likhte waqt sabse important baat hai ki formula = sign se start ho.

Cell references use karne se calculations automatic aur easy ho jati hain.

🎓 Lesson Summary

Is lesson mein humne seekha:

✅ Formula kya hai
✅ = Sign ka use
✅ Addition
✅ Subtraction
✅ Multiplication
✅ Division
✅ Cell Reference
✅ Basic Operators
✅ Total Calculation
✅ Business Calculation
✅ Formula Bar